﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;

namespace Contrast
{
   public static class SqlDAL
    {
        /// <summary>
        /// 根据用户ID获取卡券
        /// </summary>
        /// <param name="UserID"></param>
        /// <returns></returns>
        public static DataTable GetHospitalList(string name)
        {
            string sql = @"select * from hospital_info ";
            if (name != "")
            {
                sql += "where name like '%" + name + "%'";
            }

            SqlParameter[] parList = {
           
               };
            DataTable tab = SqlDbHelper.ExecuteDataTable(sql, parList);
            if (tab!=null)
            {
                return tab;
            }
            return null;
           
        }
    }
}
